Upgrade System Components

Perform the tasks in the following sections - in order, to upgrade the complete OneStream system.

Uninstall OneStream Servers

  1. Select Control Panel > Programs and Features > Uninstall a Program and locate the OneStream Servers component.

  2. Right-click OneStream Servers and select Uninstall.

Uninstall OneStream Client API

If installed, perform the following steps to uninstall the Client API:

  1. Select Control Panel > Programs and Features > Uninstall a Program and locate the OneStream Client API component.

  2. Right-click OneStream Client API and select Uninstall.

Re-Install OneStream Servers on an Application Server

This is the primary installation package that performs a complete server setup, including the web server, application server and all utilities. You can perform a custom install to choose the appropriate server components.

  1. Browse to the OneStream Servers package, right-click OneStreamServers-#.msi and select Install to run the server installation.

  2. Click Next on the landing page and accept the License Agreement.

  3. Specify the directory where the software was previously installed and click Next.

  4. Select Custom.

  5. On Select Features, choose Application Server and Server Configuration Utility and click Next.

    NOTE: Choose the Database Configuration Utility and Upgrade Assistant Utility if the application server is the server where the Database Configuration Utility was previously installed.

  6. Click Install then Finish.

Re-Install OneStream Servers on a Web Server

  1. Browse to the OneStream Servers package, right-click OneStreamServers-#.msi and select Install.

  2. Click Next and accept the License Agreement.

  3. Specify the directory where the software was previously installed and click Next.

  4. Select Custom.

  5. On Select Features, choose Web Server and Server Configuration Utility and click Next.

  6. Click Install then Finish.

Re-Install OneStream for Desktop

  1. Browse to the OneStream package, right-click OneStreamDesktop-#.msi and select Install.

  2. Click Next and accept the License Agreement.

  3. Select Custom.

  4. Select the directory where the software was previously installed and click Next.

  5. On Select Features, select all options and click Next.

  6. Click Install then Finish.

Upgrade the Framework and Application Databases

Before performing these steps, have a database administrator back up all OneStream databases.

  1. On the OneStream application server with the OneStream Database Configuration Utility installed, select Start > Programs > OneStream Software > OneStream Database Configuration Utility.

  2. Right-click the utility and select Run as Administrator.

  3. Right-click OneStream Framework Database and choose Upgrade Database Version.

    NOTE: If this is disabled, an upgrade is not required.

    NOTE: If you get an error, check the log for details: C:\Program Files\OneStream Software\XFDatabaseConfig\Log

  4. Confirm the upgrade.

  5. Repeat the upgrade for each Application database and the Framework database until the option is disabled. This will indicate you have updated to the current version.

Run the Upgrade Assistant Utility

Guidance for self-hosted environments

This is an additional step for when upgrading from a Platform Release pre 8.0 to a Platform Release 8.0 or later and must be performed. Specifically, this version of the Upgrade Assistant Utility will convert any legacy reports that were stored in CodeDOM format to now be stored as XML.

  1. On the OneStream application server with the OneStream Upgrade Assistant Utility installed, select Start > Programs > OneStream Software > OneStream Upgrade Assistant Utility.

  2. From the command line enter:

    xfupgradeassistant -c C:\OneStreamShare\Config\XFAppServerConfig.xml -t ReportLayoutBytes -v -update

    NOTE: C:\OneStreamShare\Config is the default path to the configuration file. You must update this path if it has been modified for your environment.

  3. Enter exit to close the utility.

  4. Restart IIS.

Update the ASP.NET Configuration File

The ASP.NET Configuration file (appsettings.json) must be updated on every server / folder as outlined below:

  • Application server

    • C:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\appsettings.json

    • C:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamMgmt\appsettings.json

  • Web servers:

    • C:\Program Files\OneStream Software\OneStreamWebRoot\OneStreamWeb\appsettings.json

    • C:\Program Files\OneStream Software\OneStreamWebApiRoot\OneStreamWebApi\appsettings.json

    • C:\Program Files\OneStream Software\OneStreamWebUIRoot\OneStreamWebUI\appsettings.json

  1. On each OneStream server, launch the OneStream Server Configuration Utility by clicking Start > Programs > OneStream Software > Server Configuration Utility.

  2. Right-click the utility and select Run as Administrator.

  3. Choose File > Open ASP.NET Configuration File and browse to the appropriate location from the folders above.

  4. Select the appsettings.json file.

  5. When the file opens, copy the directory path of the configuration files.

    NOTE: This path is commonly set to C:\OneStreamShare\Config

  6. Enable HTTP and Enable HTTPS are enabled by default.

    NOTE: Clear Enable HTTP when SSL is enabled or clear Enable HTTPS when SSL is not enabled.

  7. Save and close the file.

  8. Repeat these steps on each web and app server in the environment.

To update the Open Id Redirect Url perform the following:

Update the Configuration Files

  1. Open the Application Server Configuration file from C:\OneStreamShare\Config in a text editor and select Save.

  2. Open the OneStream Server Configuration Utility, Run as Administrator.

  3. Select File > Open and select the file from C:\OneStreamShare\Config. In Database Server Connections, select the ellipsis and update the command time-outs for the OneStream Database Server connection:

    Short = 90    *must do

    Large =900 (minimum or 900)

  4. Select File > Save and close the file.

  5. Repeat these steps for the Web Server Configuration file.

Update and Configure IIS

  1. On each OneStream server, open the OneStream Server Configuration Utility by clicking Start > Programs > OneStream Software > Server Configuration Utility.

  2. Right-click the utility and select Run as Administrator.

  3. Choose Tools > Configure IIS.

  4. In Configure IIS, specify the following:

    1. For Web Site Name, enter the name of the OneStream IIS Website to update.

    2. The OneStream App Server, and Web Server sites.

  5. Select Update IIS Default Settings.

  6. Select options to update IIS for the appropriate websites:

    1. Use Web Server Settings: Specify the Web Server site.

    2. Use App Server Settings: Specify the App Server site.

    3. User Account Type: Specify Custom Account, then enter the user name and password of the OneStream Service account.

  7. Click Update IIS Settings then OK.

  8. Repeat these steps to set the appropriate IIS settings for the application pools in IIS.

  9. Click Reset IIS.

Test the Windows Client Login Using ClickOnce

  1. Using the Microsoft Edge Web Browser, navigate to the OneStream Windows App URL:

  • On Prem: http://<webserver>:50001/OneStreamWeb

  • Cloud: https://<customer>.onestreamcloud.com/OneStreamWeb

  1. Click Open to launch the ClickOnce Windows app.

  2. Confirm that you can log in.

  3. From Application, select System Administration then click Connect.

  4. Select System > Tools > Environment to identify the application servers and their status.

  5. Verify that each server is active.

Test the Browser Experience Login

  1. Navigate to the OneStream Browser Experience URL:

  • On Prem for Browser Experience: http://<webserver>:50001

  • Cloud for Browser Experience https://<customer>.onestreamcloud.com

  1. Confirm that you can log in.

Verify the Application

  1. Compile all business rules, ensure to:

    • Right-click the grid and export any errors for analysis using an Excel file format.

    • Apply updates as needed.

  2. Download and import the Standard Application and Standard System Reports from the MarketPlace portal on the Solution Exchange.